12(select DISTINCT IF(p.products_sort_order = 0, 2, 1) as sort_query, c.categories_id, p.products_image, pd.products_name, p.*, if(p2c.sort_order = 0, 9999999, p2c.sort_order) as product_in_category_sort, p.products_id, IF(c.sort_order = 0, 1000, c.sort_order) as csort, p.products_date_available, p.manufacturers_id, p.products_price, p.products_tax_class_id, p.products_quantity, p.products_unlimited_quantity,p.products_status, p.products_order_type, p.products_sort_order, p.products_not_for_sale, p.products_ordered, p.products_not_for_sale_show, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price, p.products_external_url, p.forawrd_product_attribute_detail from products p, products_description pd, manufacturers m, products_to_categories p2c left join specials s on p2c.products_id = s.products_id left join categories c on c.categories_id = p2c.categories_id where m.manufacturers_status='1' and c.categories_status = '1' and p.products_status = '1' and p.products_public = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '327' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and (p2c.categories_id = '1102') group by p.products_id order by product_in_category_sort asc ,products_order_type desc, products_sort_order, csort asc, sort_query asc, products_ordered asc,products_name asc, products_model asc)
|
Viewing 1 to 2 (of 2 items)
|
|
|
|
| |
|
|
|
|
